Excel Formulas and Functions: The Step by Step Excel Book for Beginners on how to Master Lookup Formulas using the XLOOKUP Function by Suman Harjit

Author:Suman, Harjit [Suman, Harjit]
Language: eng
Format: epub
Published: 2020-08-03T16:00:00+00:00

Populating the Employee Name

I will now lookup the employee name for employee ID 1089.

The formula to extract the employee name in cell B4 is:

=XLOOKUP(B1,'Employee Database (Horizontal)'!B1:U1,'Employee Database (Horizontal)'!B4:U4)

The employee names are in row 4 in the Employee Database (Horizontal) tab so therefore the return_array argument is B4:U4. The lookup_value and the lookup_array arguments remain the same as the previous two XLOOKUP formulas.

Populating the Years in Service

Finally, I will populate the number of years in service for employee ID 1089 in the Chapter 5 Worksheet tab.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.